-- Script Date: 19/11/2013 12:38  - ErikEJ.SqlCeScripting version 3.5.2.32
CREATE TABLE [LEADERS] (
  [WK] tinyint NOT NULL
, [NAME] nvarchar(10) NOT NULL
, [SURNAME] nvarchar(10) NOT NULL
, [ROLE] nvarchar(3) NOT NULL
, [TEAM] nvarchar(3) NOT NULL
, [OPP] nvarchar(3) NOT NULL
, [AH] nvarchar(4) NOT NULL
, [GAMES_G] tinyint NOT NULL
, [GAMES_GS] tinyint NOT NULL
, [PASSING_COMP] tinyint NULL
, [PASSING_ATT] tinyint NULL
, [PASSING_YDS] int NULL
, [PASSING_TD] tinyint NULL
, [PASSING_INT] tinyint NULL
, [RUSHING_ATT] tinyint NULL
, [RUSHING_YDS] int NULL
, [RUSHING_LNG] tinyint NULL
, [RUSHING_TD] tinyint NULL
, [RECEIVING_REC] tinyint NULL
, [RECEIVING_YDS] int NULL
, [RECEIVING_LNG] tinyint NULL
, [RECEIVING_TD] tinyint NULL
, [FUMBLES_LOST] tinyint NULL
, [OVERALLFGS_LNG] tinyint NULL
, [OVERALLFGS_FGATT] tinyint NULL
, [OVERALLFGS_FGM] tinyint NULL
, [TACKLES_COMB] tinyint NULL
, [TACKLES_TOTAL] tinyint NULL
, [TACKLES_AST] tinyint NULL
, [TACKLES_SCK] tinyint NULL
, [TACKLES_SFTY] tinyint NULL
, [INTERCEPTIONS_PDEF] tinyint NULL
, [INTERCEPTIONS_INT] tinyint NULL
, [FUMBLES_FF] tinyint NULL
);
GO
ALTER TABLE [LEADERS] ADD CONSTRAINT [PK_LEADERS] PRIMARY KEY ([WK],[NAME],[SURNAME],[TEAM]);
GO
